StudentGroup 
EntityType  Independent 
Logical Entity Name  StudentGroup 
Default Table Name  SyGroups 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

StudentGroup Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
Code    CHAR(8)  NO 
 
Name    VARCHAR(60)  NO 
 
CampusGroupId    INTEGER  NO 
 
IsActive    BIT  NO 
 
SQLQuery    TEXT  NO 
 
GroupType    CHAR(1)  NO 
 
OwnerStaffId    INTEGER  NO 
 
IsPublic    BIT  NO 
 
ModFlag    CHAR(1)  NO 
 
LastModifiedUserId    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
StudentGroupId(PK)    INTEGER  NO 
 
ExpirationDate    DATETIME  YES 
 
JobFrequency    CHAR(1)  NO 
 
LastRefreshDate    DATETIME  NO 
 
IsPortalGroup    BIT  NO 
 
IsUsedForAutoAwardRules    BIT  NO 
 
IsUsedForAutoAwardCoa    BIT  NO 
 
PreserveManualAddedStudentsOnRefresh    BIT  NO 
 
IsSprocQuery    BIT  NO 
 

StudentGroup Keys 
Key Name  Key Type  Keys 
SyGroups_SyGroupsID_U_C_IDX  PrimaryKey  StudentGroupId 

StudentGroup Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
RegistrationGroupTerm  Non-Identifying  One To Zero or More          NO 
RegistrationRule  Non-Identifying  One To Zero or More          NO 
FaSapTable  Non-Identifying  One To Zero or More          NO 
FaProgramVersionCOA  Non-Identifying  One To Zero or More          NO 
HsRoomMateMatchCriteria  Non-Identifying  One To Zero or More          NO 
SaRefundCalcStudentGroup_FAA  Non-Identifying  One To Zero or More          NO 
SaRefundCalcStudentGroup  Non-Identifying  One To Zero or More          NO 
SaReturnOfT4StudentGroup_Faa  Non-Identifying  One To Zero or More          NO 
Campus  Non-Identifying  One To Zero or More          NO 
Campus  Non-Identifying  One To Zero or More          NO 
StudentGroupStaffAccess  Non-Identifying  One To Zero or More          NO 
AchBatchFileCompanyDetail  Non-Identifying  One To Zero or More          NO 
CreditCardBatchTransaction  Non-Identifying  One To Zero or More          NO 
RegistrationRule  Non-Identifying  One To Zero or More          NO 

StudentGroup Check Constraints 
Check Constraint Name  CheckConstraint 

StudentGroup Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StudentGroup 
NO       
Physical (Microsoft SQL Server)
dbo.SyGroups 
NO       

StudentGroup Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  CourseRegistration 
Logical  ElectronicPaymentProcessing 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 
Physical (Microsoft SQL Server)  System 

StudentGroup Data Movement Rules 
Name  Type  Rule Text/Value